/**
 * Students wich will choise a reaserch topic have to got relation with year and research topic
 */

const Sequelize = require('sequelize');
const MySQLManager = require('../utils/MySQLManager');


const topic_students = MySQLManager.define('topic_students', {

    // 学生的年度
	student_year: {
        type: Sequelize.STRING,
        allowNull: false,
        unique: 'name',
    },

    topic_name: {
        type: Sequelize.STRING,
        defaultValue: ''
    },

    teacher_fullname: {
        type: Sequelize.STRING,
        defaultValue: ''
    },

    //   学生学号
	student_user_name: {
		type: Sequelize.STRING,
        allowNull: false,
        unique: 'name',
    },

    //   题目编号
    topic_id: {
        type: Sequelize.STRING
    },

    //   题目名称
    // topic_name: {
    //     type: Sequelize.STRING
    // },
    
    //   教师编号
    teacher_id: {
        type: Sequelize.STRING
    },

    // 成绩
    topic_grade: {
        type: Sequelize.STRING,
        defaultValue: 'X'
    },

    // 状态 0已报名 1未报名 2老师确认a
    student_status: {
        type: Sequelize.STRING,
        defaultValue: '1'
    },

  


    // //   备用字段
	//   beiyong1: {
	// 	type: Sequelize.STRING
	//   },
	//   beiyong2: {
	// 	type: Sequelize.STRING
	//   },
	//   beiyong3: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong4: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong5: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong6: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong7: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong8: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong9: {
	// 	type: Sequelize.STRING
    //   },
    //   beiyong10: {
	// 	type: Sequelize.STRING
	//   }
});


module.exports = topic_students